Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	90642
Missing cells	292
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	11.1 MiB
Average record size in memory	128.0 B

Variable types

Categorical	7
Numeric	9

Alerts

`province` has a high cardinality: 90 distinct values	High cardinality
`municipality` has a high cardinality: 1454 distinct values	High cardinality
`barangay` has a high cardinality: 26402 distinct values	High cardinality
`precincts` has a high cardinality: 41457 distinct values	High cardinality
`polling_center` has a high cardinality: 28639 distinct values	High cardinality
`timestamp` has a high cardinality: 29598 distinct values	High cardinality
`registered_voters` is highly correlated with `ballots_cast`	High correlation
`ballots_cast` is highly correlated with `registered_voters`	High correlation
`registered_voters` is highly correlated with `ballots_cast`	High correlation
`ballots_cast` is highly correlated with `registered_voters`	High correlation
`registered_voters` is highly correlated with `ballots_cast`	High correlation
`ballots_cast` is highly correlated with `registered_voters`	High correlation
`region` is highly correlated with `province`	High correlation
`province` is highly correlated with `region`	High correlation
`region` is highly correlated with `province` and 6 other fields	High correlation
`province` is highly correlated with `region` and 7 other fields	High correlation
`clustered_precinct` is highly correlated with `region` and 4 other fields	High correlation
`cayetano` is highly correlated with `region` and 2 other fields	High correlation
`escudero` is highly correlated with `province`	High correlation
`marcos` is highly correlated with `region` and 2 other fields	High correlation
`robredo` is highly correlated with `region` and 2 other fields	High correlation
`registered_voters` is highly correlated with `region` and 3 other fields	High correlation
`ballots_cast` is highly correlated with `region` and 3 other fields	High correlation
`clustered_precinct` has unique values	Unique
`cayetano` has 1078 (1.2%) zeros	Zeros
`honasan` has 3284 (3.6%) zeros	Zeros
`trillanes` has 4286 (4.7%) zeros	Zeros

Reproduction

Analysis started	2022-05-24 11:22:00.758961
Analysis finished	2022-05-24 11:22:20.939929
Duration	20.18 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

region
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

REGION IV-A	12034
REGION III	9504
NCR	9234
REGION VIII	5705
REGION VII	5700
Other values (14)	48465

Length

Max length	11
Median length	9
Mean length	8.35064319
Min length	3

Characters and Unicode

Total characters	756919
Distinct characters	14
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	REGION I
2nd row	REGION I
3rd row	REGION I
4th row	REGION I
5th row	REGION I

Common Values

Value	Count	Frequency (%)
REGION IV-A	12034	13.3%
REGION III	9504	10.5%
NCR	9234	10.2%
REGION VIII	5705	6.3%
REGION VII	5700	6.3%
REGION V	5554	6.1%
REGION I	5300	5.8%
REGION VI	5016	5.5%
REGION X	4207	4.6%
REGION XI	3942	4.3%
Other values (9)	24446	27.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
region	72134	44.3%
iv-a	12034	7.4%
iii	9504	5.8%
ncr	9234	5.7%
viii	5705	3.5%
vii	5700	3.5%
v	5554	3.4%
i	5300	3.3%
vi	5016	3.1%
x	4207	2.6%
Other values (10)	28388	17.4%

Most occurring characters

Value	Count	Frequency (%)
I	185788	24.5%
R	90159	11.9%
N	85138	11.2%
O	72617	9.6%
E	72134	9.5%
G	72134	9.5%
	72134	9.5%
V	37250	4.9%
A	17538	2.3%
X	17105	2.3%
Other values (4)	34922	4.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	669993	88.5%
Space Separator	72134	9.5%
Dash Punctuation	14792	2.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	185788	27.7%
R	90159	13.5%
N	85138	12.7%
O	72617	10.8%
E	72134	10.8%
G	72134	10.8%
V	37250	5.6%
A	17538	2.6%
X	17105	2.6%
C	11138	1.7%
Other values (2)	8992	1.3%

Space Separator

Value	Count	Frequency (%)
	72134	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	14792	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	669993	88.5%
Common	86926	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	185788	27.7%
R	90159	13.5%
N	85138	12.7%
O	72617	10.8%
E	72134	10.8%
G	72134	10.8%
V	37250	5.6%
A	17538	2.6%
X	17105	2.6%
C	11138	1.7%
Other values (2)	8992	1.3%

Common

Value	Count	Frequency (%)
	72134	83.0%
-	14792	17.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	756919	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	185788	24.5%
R	90159	11.9%
N	85138	11.2%
O	72617	9.6%
E	72134	9.5%
G	72134	9.5%
	72134	9.5%
V	37250	4.9%
A	17538	2.3%
X	17105	2.3%
Other values (4)	34922	4.6%

province
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

CEBU	4021
NATIONAL CAPITAL REGION - SECOND DISTRICT	2879
CAVITE	2795
PANGASINAN	2777
ILOILO	2726
Other values (85)	75444

Length

Max length	41
Median length	21
Mean length	12.79070409
Min length	4

Characters and Unicode

Total characters	1159375
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PANGASINAN
2nd row	PANGASINAN
3rd row	PANGASINAN
4th row	PANGASINAN
5th row	PANGASINAN

Common Values

Value	Count	Frequency (%)
CEBU	4021	4.4%
NATIONAL CAPITAL REGION - SECOND DISTRICT	2879	3.2%
CAVITE	2795	3.1%
PANGASINAN	2777	3.1%
ILOILO	2726	3.0%
LAGUNA	2552	2.8%
BATANGAS	2495	2.8%
NEGROS OCCIDENTAL	2493	2.8%
BULACAN	2435	2.7%
LEYTE	2288	2.5%
Other values (80)	63181	69.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
del	9317	5.2%
	9234	5.2%
national	8656	4.9%
capital	8656	4.9%
region	8656	4.9%
sur	8263	4.6%
district	6996	3.9%
norte	5063	2.8%
davao	4070	2.3%
cebu	4021	2.3%
Other values (92)	105288	59.1%

Most occurring characters

Value	Count	Frequency (%)
A	172873	14.9%
N	101157	8.7%
I	89331	7.7%
	87578	7.6%
O	83677	7.2%
T	76244	6.6%
E	72556	6.3%
L	68199	5.9%
R	62462	5.4%
S	54719	4.7%
Other values (20)	290579	25.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1054913	91.0%
Space Separator	87578	7.6%
Dash Punctuation	9574	0.8%
Open Punctuation	3079	0.3%
Close Punctuation	3079	0.3%
Other Punctuation	1152	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	172873	16.4%
N	101157	9.6%
I	89331	8.5%
O	83677	7.9%
T	76244	7.2%
E	72556	6.9%
L	68199	6.5%
R	62462	5.9%
S	54719	5.2%
C	49935	4.7%
Other values (15)	223760	21.2%

Space Separator

Value	Count	Frequency (%)
	87578	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	9574	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3079	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3079	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1152	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1054913	91.0%
Common	104462	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	172873	16.4%
N	101157	9.6%
I	89331	8.5%
O	83677	7.9%
T	76244	7.2%
E	72556	6.9%
L	68199	6.5%
R	62462	5.9%
S	54719	5.2%
C	49935	4.7%
Other values (15)	223760	21.2%

Common

Value	Count	Frequency (%)
	87578	83.8%
-	9574	9.2%
(	3079	2.9%
)	3079	2.9%
.	1152	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1159375	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	172873	14.9%
N	101157	8.7%
I	89331	7.7%
	87578	7.6%
O	83677	7.2%
T	76244	6.6%
E	72556	6.3%
L	68199	5.9%
R	62462	5.4%
S	54719	4.7%
Other values (20)	290579	25.1%

municipality
Categorical

HIGH CARDINALITY

Distinct	1454
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

QUEZON CITY	1651
DAVAO CITY	1279
CALOOCAN CITY	957
CEBU CITY	836
CITY OF ANTIPOLO	638
Other values (1449)	85281

Length

Max length	47
Median length	30
Mean length	9.934765341
Min length	3

Characters and Unicode

Total characters	900507
Distinct characters	34
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	CALASIAO
2nd row	CALASIAO
3rd row	CALASIAO
4th row	CALASIAO
5th row	CALASIAO

Common Values

Value	Count	Frequency (%)
QUEZON CITY	1651	1.8%
DAVAO CITY	1279	1.4%
CALOOCAN CITY	957	1.1%
CEBU CITY	836	0.9%
CITY OF ANTIPOLO	638	0.7%
ZAMBOANGA CITY	616	0.7%
TONDO	557	0.6%
CITY OF MAKATI	556	0.6%
SANTA CRUZ	545	0.6%
CITY OF PASIG	533	0.6%
Other values (1444)	82474	91.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	28936	19.7%
of	6087	4.2%
san	5751	3.9%
santa	2181	1.5%
quezon	1876	1.3%
davao	1279	0.9%
caloocan	957	0.7%
jose	934	0.6%
cebu	836	0.6%
general	785	0.5%
Other values (1530)	96996	66.2%

Most occurring characters

Value	Count	Frequency (%)
A	155763	17.3%
I	73815	8.2%
N	71693	8.0%
O	62985	7.0%
T	58241	6.5%
	57936	6.4%
C	52322	5.8%
L	43156	4.8%
Y	39979	4.4%
S	35465	3.9%
Other values (24)	249152	27.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	834110	92.6%
Space Separator	57936	6.4%
Open Punctuation	3330	0.4%
Close Punctuation	3330	0.4%
Dash Punctuation	975	0.1%
Other Punctuation	754	0.1%
Modifier Symbol	72	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	155763	18.7%
I	73815	8.8%
N	71693	8.6%
O	62985	7.6%
T	58241	7.0%
C	52322	6.3%
L	43156	5.2%
Y	39979	4.8%
S	35465	4.3%
G	30466	3.7%
Other values (17)	210225	25.2%

Other Punctuation

Value	Count	Frequency (%)
.	612	81.2%
'	142	18.8%

Space Separator

Value	Count	Frequency (%)
	57936	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3330	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3330	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	975	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	72	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	834110	92.6%
Common	66397	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	155763	18.7%
I	73815	8.8%
N	71693	8.6%
O	62985	7.6%
T	58241	7.0%
C	52322	6.3%
L	43156	5.2%
Y	39979	4.8%
S	35465	4.3%
G	30466	3.7%
Other values (17)	210225	25.2%

Common

Value	Count	Frequency (%)
	57936	87.3%
(	3330	5.0%
)	3330	5.0%
-	975	1.5%
.	612	0.9%
'	142	0.2%
`	72	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	898329	99.8%
None	2178	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	155763	17.3%
I	73815	8.2%
N	71693	8.0%
O	62985	7.0%
T	58241	6.5%
	57936	6.4%
C	52322	5.8%
L	43156	4.8%
Y	39979	4.5%
S	35465	3.9%
Other values (23)	246974	27.5%

None

Value	Count	Frequency (%)
Ñ	2178	100.0%

barangay
Categorical

HIGH CARDINALITY

Distinct	26402
Distinct (%)	29.1%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

POBLACION	2276
SAN ISIDRO	762
SAN JOSE	548
SAN ROQUE	435
SAN ANTONIO	417
Other values (26397)	86204

Length

Max length	54
Median length	44
Mean length	10.00989607
Min length	2

Characters and Unicode

Total characters	907317
Distinct characters	46
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11731 ?
Unique (%)	12.9%

Sample

1st row	BUENLAG
2nd row	BUENLAG
3rd row	BUENLAG
4th row	BUENLAG
5th row	BUENLAG

Common Values

Value	Count	Frequency (%)
POBLACION	2276	2.5%
SAN ISIDRO	762	0.8%
SAN JOSE	548	0.6%
SAN ROQUE	435	0.5%
SAN ANTONIO	417	0.5%
SAN JUAN	398	0.4%
SAN VICENTE	396	0.4%
SANTO NIÑO	357	0.4%
SANTA CRUZ	320	0.4%
SAN MIGUEL	251	0.3%
Other values (26392)	84482	93.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	7536	5.4%
pob	7019	5.0%
barangay	5614	4.0%
poblacion	4223	3.0%
santa	1846	1.3%
i	1107	0.8%
santo	1093	0.8%
ii	1084	0.8%
isidro	1002	0.7%
jose	942	0.7%
Other values (21702)	108888	77.6%

Most occurring characters

Value	Count	Frequency (%)
A	166511	18.4%
N	88980	9.8%
O	65970	7.3%
I	55326	6.1%
	52192	5.8%
B	45124	5.0%
L	43102	4.8%
G	40869	4.5%
S	38313	4.2%
T	32779	3.6%
Other values (36)	278151	30.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	808429	89.1%
Space Separator	52192	5.8%
Decimal Number	13307	1.5%
Close Punctuation	9863	1.1%
Open Punctuation	9863	1.1%
Other Punctuation	9442	1.0%
Dash Punctuation	4208	0.5%
Connector Punctuation	13	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	166511	20.6%
N	88980	11.0%
O	65970	8.2%
I	55326	6.8%
B	45124	5.6%
L	43102	5.3%
G	40869	5.1%
S	38313	4.7%
T	32779	4.1%
R	30975	3.8%
Other values (17)	200480	24.8%

Decimal Number

Value	Count	Frequency (%)
1	2808	21.1%
2	1645	12.4%
3	1374	10.3%
7	1311	9.9%
6	1250	9.4%
4	1174	8.8%
5	1132	8.5%
8	1126	8.5%
9	781	5.9%
0	706	5.3%

Other Punctuation

Value	Count	Frequency (%)
.	9096	96.3%
,	285	3.0%
'	42	0.4%
*	19	0.2%

Space Separator

Value	Count	Frequency (%)
	52192	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	9863	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	9863	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4208	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	808429	89.1%
Common	98888	10.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	166511	20.6%
N	88980	11.0%
O	65970	8.2%
I	55326	6.8%
B	45124	5.6%
L	43102	5.3%
G	40869	5.1%
S	38313	4.7%
T	32779	4.1%
R	30975	3.8%
Other values (17)	200480	24.8%

Common

Value	Count	Frequency (%)
	52192	52.8%
)	9863	10.0%
(	9863	10.0%
.	9096	9.2%
-	4208	4.3%
1	2808	2.8%
2	1645	1.7%
3	1374	1.4%
7	1311	1.3%
6	1250	1.3%
Other values (9)	5278	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	906374	99.9%
None	943	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	166511	18.4%
N	88980	9.8%
O	65970	7.3%
I	55326	6.1%
	52192	5.8%
B	45124	5.0%
L	43102	4.8%
G	40869	4.5%
S	38313	4.2%
T	32779	3.6%
Other values (35)	277208	30.6%

None

Value	Count	Frequency (%)
Ñ	943	100.0%

clustered_precinct
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	90642
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41417585.32

Minimum	1010001
Maximum	93150065
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	1010001
5-th percentile	7100014.05
Q1	22170553.25
median	39101196.5
Q3	58080184.75
95-th percentile	76040242.95
Maximum	93150065
Range	92140064
Interquartile range (IQR)	35909631.5

Descriptive statistics

Standard deviation	22649418.45
Coefficient of variation (CV)	0.5468551167
Kurtosis	-1.089332949
Mean	41417585.32
Median Absolute Deviation (MAD)	17901146
Skewness	0.1356742081
Sum	3.754172768 × 10¹²
Variance	5.129961563 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55170026	1	< 0.1%
82110058	1	< 0.1%
82110021	1	< 0.1%
82110018	1	< 0.1%
82110006	1	< 0.1%
82110026	1	< 0.1%
82110027	1	< 0.1%
82110025	1	< 0.1%
82110067	1	< 0.1%
82110066	1	< 0.1%
Other values (90632)	90632	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1010001	1	< 0.1%
1010002	1	< 0.1%
1010003	1	< 0.1%
1010004	1	< 0.1%
1010005	1	< 0.1%
1010006	1	< 0.1%
1010007	1	< 0.1%
1010008	1	< 0.1%
1010009	1	< 0.1%
1010010	1	< 0.1%

Value	Count	Frequency (%)
93150065	1	< 0.1%
93150064	1	< 0.1%
93150063	1	< 0.1%
93150062	1	< 0.1%
93150061	1	< 0.1%
93150060	1	< 0.1%
93150059	1	< 0.1%
93150058	1	< 0.1%
93150057	1	< 0.1%
93150056	1	< 0.1%

cayetano
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	496
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.64745924

Minimum	0
Maximum	612
Zeros	1078
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	18
median	40
Q3	72
95-th percentile	223
Maximum	612
Range	612
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	72.24853121
Coefficient of variation (CV)	1.153255568
Kurtosis	6.242696969
Mean	62.64745924
Median Absolute Deviation (MAD)	25
Skewness	2.347674801
Sum	5678491
Variance	5219.850262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	1393	1.5%
8	1370	1.5%
7	1339	1.5%
11	1320	1.5%
10	1318	1.5%
6	1311	1.4%
5	1308	1.4%
14	1290	1.4%
13	1281	1.4%
12	1271	1.4%
Other values (486)	77441	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1078	1.2%
1	1043	1.2%
2	1169	1.3%
3	1250	1.4%
4	1267	1.4%
5	1308	1.4%
6	1311	1.4%
7	1339	1.5%
8	1370	1.5%
9	1393	1.5%

Value	Count	Frequency (%)
612	1	< 0.1%
539	1	< 0.1%
532	1	< 0.1%
514	1	< 0.1%
513	1	< 0.1%
506	2	< 0.1%
505	1	< 0.1%
504	1	< 0.1%
502	1	< 0.1%
497	1	< 0.1%

escudero
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	450
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53.09176761

Minimum	0
Maximum	692
Zeros	853
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	6
Q1	25
median	44
Q3	72
95-th percentile	123
Maximum	692
Range	692
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	42.24989459
Coefficient of variation (CV)	0.7957899404
Kurtosis	15.74278833
Mean	53.09176761
Median Absolute Deviation (MAD)	23
Skewness	2.629427762
Sum	4812344
Variance	1785.053592
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	1255	1.4%
38	1196	1.3%
30	1189	1.3%
35	1185	1.3%
29	1181	1.3%
26	1168	1.3%
28	1165	1.3%
36	1163	1.3%
33	1158	1.3%
34	1146	1.3%
Other values (440)	78836	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	853	0.9%
1	638	0.7%
2	683	0.8%
3	708	0.8%
4	720	0.8%
5	706	0.8%
6	729	0.8%
7	773	0.9%
8	753	0.8%
9	853	0.9%

Value	Count	Frequency (%)
692	1	< 0.1%
676	1	< 0.1%
660	1	< 0.1%
553	1	< 0.1%
552	1	< 0.1%
539	2	< 0.1%
537	1	< 0.1%
518	1	< 0.1%
516	1	< 0.1%
514	1	< 0.1%

honasan
Real number (ℝ_≥0)

ZEROS

Distinct	204
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.389510382

Minimum	0
Maximum	734
Zeros	3284
Zeros (%)	3.6%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	3
median	6
Q3	10
95-th percentile	22
Maximum	734
Range	734
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	12.54994631
Coefficient of variation (CV)	1.495909265
Kurtosis	651.8370312
Mean	8.389510382
Median Absolute Deviation (MAD)	3
Skewness	18.83783216
Sum	760442
Variance	157.5011523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	8486	9.4%
5	8307	9.2%
3	8197	9.0%
6	7689	8.5%
2	7074	7.8%
7	6598	7.3%
8	5798	6.4%
1	5338	5.9%
9	4789	5.3%
10	4032	4.4%
Other values (194)	24334	26.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3284	3.6%
1	5338	5.9%
2	7074	7.8%
3	8197	9.0%
4	8486	9.4%
5	8307	9.2%
6	7689	8.5%
7	6598	7.3%
8	5798	6.4%
9	4789	5.3%

Value	Count	Frequency (%)
734	1	< 0.1%
565	1	< 0.1%
531	1	< 0.1%
528	1	< 0.1%
518	1	< 0.1%
517	1	< 0.1%
506	1	< 0.1%
502	1	< 0.1%
501	1	< 0.1%
500	1	< 0.1%

marcos
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	668
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.3011628

Minimum	0
Maximum	756
Zeros	374
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	60
median	129
Q3	225
95-th percentile	363
Maximum	756
Range	756
Interquartile range (IQR)	165

Descriptive statistics

Standard deviation	112.8127294
Coefficient of variation (CV)	0.7407213926
Kurtosis	0.8069760853
Mean	152.3011628
Median Absolute Deviation (MAD)	79
Skewness	0.9475807224
Sum	13804882
Variance	12726.71192
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	463	0.5%
31	454	0.5%
43	453	0.5%
18	444	0.5%
17	434	0.5%
22	431	0.5%
21	431	0.5%
29	429	0.5%
45	423	0.5%
28	423	0.5%
Other values (658)	86257	95.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	374	0.4%
1	126	0.1%
2	165	0.2%
3	190	0.2%
4	218	0.2%
5	253	0.3%
6	280	0.3%
7	291	0.3%
8	324	0.4%
9	309	0.3%

Value	Count	Frequency (%)
756	1	< 0.1%
753	1	< 0.1%
749	1	< 0.1%
730	1	< 0.1%
723	2	< 0.1%
714	1	< 0.1%
711	1	< 0.1%
698	1	< 0.1%
695	1	< 0.1%
694	1	< 0.1%

robredo
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	629
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	154.712385

Minimum	0
Maximum	754
Zeros	420
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	87
median	144
Q3	204
95-th percentile	339
Maximum	754
Range	754
Interquartile range (IQR)	117

Descriptive statistics

Standard deviation	95.99530347
Coefficient of variation (CV)	0.6204758816
Kurtosis	1.344355273
Mean	154.712385
Median Absolute Deviation (MAD)	58
Skewness	0.9255990239
Sum	14023440
Variance	9215.098287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
138	483	0.5%
154	477	0.5%
156	470	0.5%
150	467	0.5%
147	467	0.5%
139	466	0.5%
127	464	0.5%
137	458	0.5%
124	457	0.5%
132	457	0.5%
Other values (619)	85976	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	420	0.5%
1	226	0.2%
2	213	0.2%
3	215	0.2%
4	217	0.2%
5	209	0.2%
6	197	0.2%
7	205	0.2%
8	196	0.2%
9	194	0.2%

Value	Count	Frequency (%)
754	1	< 0.1%
751	1	< 0.1%
743	1	< 0.1%
732	1	< 0.1%
716	1	< 0.1%
708	1	< 0.1%
706	1	< 0.1%
705	1	< 0.1%
703	1	< 0.1%
698	1	< 0.1%

trillanes
Real number (ℝ_≥0)

ZEROS

Distinct	150
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.313828027

Minimum	0
Maximum	344
Zeros	4286
Zeros (%)	4.7%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4
median	7
Q3	12
95-th percentile	25
Maximum	344
Range	344
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	9.416564774
Coefficient of variation (CV)	1.011030561
Kurtosis	58.68963848
Mean	9.313828027
Median Absolute Deviation (MAD)	4
Skewness	4.603380055
Sum	844224
Variance	88.67169215
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	6656	7.3%
6	6650	7.3%
4	6645	7.3%
3	6631	7.3%
7	6017	6.6%
2	5973	6.6%
8	5470	6.0%
1	5105	5.6%
9	4817	5.3%
0	4286	4.7%
Other values (140)	32392	35.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4286	4.7%
1	5105	5.6%
2	5973	6.6%
3	6631	7.3%
4	6645	7.3%
5	6656	7.3%
6	6650	7.3%
7	6017	6.6%
8	5470	6.0%
9	4817	5.3%

Value	Count	Frequency (%)
344	1	< 0.1%
241	1	< 0.1%
230	1	< 0.1%
218	1	< 0.1%
189	1	< 0.1%
185	1	< 0.1%
183	1	< 0.1%
179	1	< 0.1%
175	1	< 0.1%
160	1	< 0.1%

registered_voters
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	771
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	591.695031

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	1
5-th percentile	279
Q1	494
median	619
Q3	722
95-th percentile	787
Maximum	1000
Range	999
Interquartile range (IQR)	228

Descriptive statistics

Standard deviation	160.0241137
Coefficient of variation (CV)	0.2704503255
Kurtosis	0.1221898841
Mean	591.695031
Median Absolute Deviation (MAD)	111
Skewness	-0.7190745318
Sum	53632421
Variance	25607.71698
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
800	567	0.6%
1000	433	0.5%
759	327	0.4%
778	326	0.4%
773	324	0.4%
798	324	0.4%
784	319	0.4%
757	316	0.3%
779	316	0.3%
765	311	0.3%
Other values (761)	87079	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
24	1	< 0.1%
26	1	< 0.1%
33	2	< 0.1%
37	1	< 0.1%
41	1	< 0.1%

Value	Count	Frequency (%)
1000	433	0.5%
950	18	< 0.1%
900	1	< 0.1%
899	1	< 0.1%
851	1	< 0.1%
848	1	< 0.1%
843	1	< 0.1%
809	1	< 0.1%
800	567	0.6%
799	306	0.3%

ballots_cast
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	793
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	482.3135302

Minimum	0
Maximum	1000
Zeros	241
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	708.3 KiB

Quantile statistics

Minimum	0
5-th percentile	229
Q1	403
median	501
Q3	583
95-th percentile	658
Maximum	1000
Range	1000
Interquartile range (IQR)	180

Descriptive statistics

Standard deviation	132.6187508
Coefficient of variation (CV)	0.2749637788
Kurtosis	0.515933745
Mean	482.3135302
Median Absolute Deviation (MAD)	88
Skewness	-0.6544986463
Sum	43717863
Variance	17587.73307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
592	324	0.4%
563	314	0.3%
517	313	0.3%
575	307	0.3%
595	304	0.3%
578	304	0.3%
556	304	0.3%
510	302	0.3%
554	301	0.3%
530	301	0.3%
Other values (783)	87568	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	241	0.3%
4	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%
15	1	< 0.1%
18	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
24	1	< 0.1%
29	2	< 0.1%

Value	Count	Frequency (%)
1000	81	0.1%
999	22	< 0.1%
998	1	< 0.1%
997	6	< 0.1%
996	1	< 0.1%
993	1	< 0.1%
992	1	< 0.1%
990	1	< 0.1%
989	2	< 0.1%
983	1	< 0.1%

precincts
Categorical

HIGH CARDINALITY

Distinct	41457
Distinct (%)	45.7%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

0001A, 0001B, 0002A, 0002B	208
0003A, 0003B, 0004A, 0004B	108
0023A, 0023B, 0024A, 0024B	102
0001A, 0002A, 0003A, 0004A	101
0020A, 0020B, 0021A, 0021B	98
Other values (41452)	90025

Length

Max length	56
Median length	55
Mean length	25.92500165
Min length	5

Characters and Unicode

Total characters	2349894
Distinct characters	40
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	32999 ?
Unique (%)	36.4%

Sample

1st row	0060A, 0060B, 0061A, 0062A
2nd row	0062B, 0063A, 0063B, 0064A
3rd row	0051C, 0052A, 0052B, 0053A, 0053B
4th row	0049A, 0050A, 0050B, 0051A, 0051B
5th row	0056C, 0057A, 0057B, 0058A, 0058B, 0059A, 0059B

Common Values

Value	Count	Frequency (%)
0001A, 0001B, 0002A, 0002B	208	0.2%
0003A, 0003B, 0004A, 0004B	108	0.1%
0023A, 0023B, 0024A, 0024B	102	0.1%
0001A, 0002A, 0003A, 0004A	101	0.1%
0020A, 0020B, 0021A, 0021B	98	0.1%
0024A, 0024B, 0025A, 0025B	92	0.1%
0012A, 0012B, 0013A, 0013B	92	0.1%
0001A, 0001B, 0002A, 0003A	91	0.1%
0025A, 0025B, 0026A, 0026B	90	0.1%
0010A, 0010B, 0011A, 0011B	89	0.1%
Other values (41447)	89571	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0001a	1590	0.4%
0002a	1577	0.4%
0003a	1571	0.4%
0004a	1569	0.4%
0005a	1566	0.4%
0009a	1560	0.4%
0006a	1560	0.4%
0007a	1557	0.4%
0010a	1555	0.4%
0008a	1553	0.4%
Other values (21716)	340223	95.6%

Most occurring characters

Value	Count	Frequency (%)
0	618335	26.3%
,	270871	11.5%
	265239	11.3%
A	210539	9.0%
1	170291	7.2%
2	117182	5.0%
B	109390	4.7%
3	100201	4.3%
4	88901	3.8%
5	82120	3.5%
Other values (30)	316825	13.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1452173	61.8%
Uppercase Letter	361611	15.4%
Other Punctuation	270871	11.5%
Space Separator	265239	11.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	210539	58.2%
B	109390	30.3%
C	20010	5.5%
D	6490	1.8%
P	6256	1.7%
E	2935	0.8%
F	1697	0.5%
G	1086	0.3%
H	744	0.2%
I	517	0.1%
Other values (18)	1947	0.5%

Decimal Number

Value	Count	Frequency (%)
0	618335	42.6%
1	170291	11.7%
2	117182	8.1%
3	100201	6.9%
4	88901	6.1%
5	82120	5.7%
6	76087	5.2%
7	70292	4.8%
8	65922	4.5%
9	62842	4.3%

Other Punctuation

Value	Count	Frequency (%)
,	270871	100.0%

Space Separator

Value	Count	Frequency (%)
	265239	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1988283	84.6%
Latin	361611	15.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	210539	58.2%
B	109390	30.3%
C	20010	5.5%
D	6490	1.8%
P	6256	1.7%
E	2935	0.8%
F	1697	0.5%
G	1086	0.3%
H	744	0.2%
I	517	0.1%
Other values (18)	1947	0.5%

Common

Value	Count	Frequency (%)
0	618335	31.1%
,	270871	13.6%
	265239	13.3%
1	170291	8.6%
2	117182	5.9%
3	100201	5.0%
4	88901	4.5%
5	82120	4.1%
6	76087	3.8%
7	70292	3.5%
Other values (2)	128764	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2349889	> 99.9%
None	5	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	618335	26.3%
,	270871	11.5%
	265239	11.3%
A	210539	9.0%
1	170291	7.2%
2	117182	5.0%
B	109390	4.7%
3	100201	4.3%
4	88901	3.8%
5	82120	3.5%
Other values (28)	316820	13.5%

None

Value	Count	Frequency (%)
À	4	80.0%
È	1	20.0%

polling_center
Categorical

HIGH CARDINALITY

Distinct	28639
Distinct (%)	31.6%
Missing	0
Missing (%)	0.0%
Memory size	708.3 KiB

SAN ISIDRO ELEMENTARY SCHOOL	389
BARANGAY HALL	296
SAN JOSE ELEMENTARY SCHOOL	277
SAN ROQUE ELEMENTARY SCHOOL	271
SAN ANTONIO ELEMENTARY SCHOOL	242
Other values (28634)	89167

Length

Max length	84
Median length	76
Mean length	26.61664571
Min length	3

Characters and Unicode

Total characters	2412586
Distinct characters	46
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12744 ?
Unique (%)	14.1%

Sample

1st row	BUENLAG ELEMENTARY SCHOOL
2nd row	BUENLAG ELEMENTARY SCHOOL
3rd row	BUENLAG ELEMENTARY SCHOOL
4th row	BUENLAG ELEMENTARY SCHOOL
5th row	BUENLAG ELEMENTARY SCHOOL

Common Values

Value	Count	Frequency (%)
SAN ISIDRO ELEMENTARY SCHOOL	389	0.4%
BARANGAY HALL	296	0.3%
SAN JOSE ELEMENTARY SCHOOL	277	0.3%
SAN ROQUE ELEMENTARY SCHOOL	271	0.3%
SAN ANTONIO ELEMENTARY SCHOOL	242	0.3%
SAN VICENTE ELEMENTARY SCHOOL	237	0.3%
RIZAL ELEMENTARY SCHOOL	201	0.2%
SAN JUAN ELEMENTARY SCHOOL	192	0.2%
SAN MIGUEL ELEMENTARY SCHOOL	188	0.2%
SAN FRANCISCO ELEMENTARY SCHOOL	144	0.2%
Other values (28629)	88205	97.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
school	82237	25.5%
elementary	56344	17.4%
elem	12686	3.9%
central	9070	2.8%
san	5990	1.9%
high	4013	1.2%
primary	3667	1.1%
hall	2636	0.8%
national	2385	0.7%
barangay	2366	0.7%
Other values (21046)	141660	43.9%

Most occurring characters

Value	Count	Frequency (%)
E	247549	10.3%
A	245279	10.2%
	234555	9.7%
O	232636	9.6%
L	221114	9.2%
N	158832	6.6%
S	129417	5.4%
C	123822	5.1%
R	113631	4.7%
T	109505	4.5%
Other values (36)	596246	24.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2145484	88.9%
Space Separator	234555	9.7%
Other Punctuation	24867	1.0%
Dash Punctuation	3977	0.2%
Open Punctuation	1315	0.1%
Close Punctuation	1299	0.1%
Decimal Number	1079	< 0.1%
Modifier Symbol	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	247549	11.5%
A	245279	11.4%
O	232636	10.8%
L	221114	10.3%
N	158832	7.4%
S	129417	6.0%
C	123822	5.8%
R	113631	5.3%
T	109505	5.1%
M	104898	4.9%
Other values (17)	458801	21.4%

Decimal Number

Value	Count	Frequency (%)
1	424	39.3%
2	258	23.9%
3	142	13.2%
8	58	5.4%
6	56	5.2%
5	54	5.0%
4	31	2.9%
7	25	2.3%
0	19	1.8%
9	12	1.1%

Other Punctuation

Value	Count	Frequency (%)
.	22663	91.1%
,	1631	6.6%
/	429	1.7%
&	144	0.6%

Space Separator

Value	Count	Frequency (%)
	234555	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3977	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1315	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1299	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2145484	88.9%
Common	267102	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	247549	11.5%
A	245279	11.4%
O	232636	10.8%
L	221114	10.3%
N	158832	7.4%
S	129417	6.0%
C	123822	5.8%
R	113631	5.3%
T	109505	5.1%
M	104898	4.9%
Other values (17)	458801	21.4%

Common

Value	Count	Frequency (%)
	234555	87.8%
.	22663	8.5%
-	3977	1.5%
,	1631	0.6%
(	1315	0.5%
)	1299	0.5%
/	429	0.2%
1	424	0.2%
2	258	0.1%
&	144	0.1%
Other values (9)	407	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2411013	99.9%
None	1573	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	247549	10.3%
A	245279	10.2%
	234555	9.7%
O	232636	9.6%
L	221114	9.2%
N	158832	6.6%
S	129417	5.4%
C	123822	5.1%
R	113631	4.7%
T	109505	4.5%
Other values (35)	594673	24.7%

None

Value	Count	Frequency (%)
Ñ	1573	100.0%

timestamp
Categorical

HIGH CARDINALITY

Distinct	29598
Distinct (%)	32.8%
Missing	292
Missing (%)	0.3%
Memory size	708.3 KiB

05/09/2016 18:32:18	88
05/09/2016 18:32:30	80
05/09/2016 18:33:05	77
05/09/2016 18:32:15	75
05/09/2016 18:33:29	67
Other values (29593)	89963

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	1716650
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15902 ?
Unique (%)	17.6%

Sample

1st row	05/09/2016 19:11:37
2nd row	05/09/2016 18:39:48
3rd row	05/09/2016 18:36:49
4th row	05/09/2016 17:12:03
5th row	05/09/2016 18:34:08

Common Values

Value	Count	Frequency (%)
05/09/2016 18:32:18	88	0.1%
05/09/2016 18:32:30	80	0.1%
05/09/2016 18:33:05	77	0.1%
05/09/2016 18:32:15	75	0.1%
05/09/2016 18:33:29	67	0.1%
05/09/2016 18:33:36	65	0.1%
05/09/2016 18:32:29	61	0.1%
05/09/2016 18:34:08	60	0.1%
05/09/2016 18:33:38	60	0.1%
05/09/2016 17:32:33	59	0.1%
Other values (29588)	89658	98.9%
(Missing)	292	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
05/09/2016	76510	42.3%
05/10/2016	12692	7.0%
05/11/2016	965	0.5%
05/12/2016	183	0.1%
18:32:18	88	< 0.1%
18:32:30	80	< 0.1%
18:33:05	77	< 0.1%
18:32:15	75	< 0.1%
18:33:29	67	< 0.1%
18:33:36	65	< 0.1%
Other values (28339)	89898	49.7%

Most occurring characters

Value	Count	Frequency (%)
0	332182	19.4%
1	214050	12.5%
/	180700	10.5%
:	180700	10.5%
2	163984	9.6%
5	136300	7.9%
9	113321	6.6%
6	108857	6.3%
	90350	5.3%
3	67554	3.9%
Other values (3)	128652	7.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1264900	73.7%
Other Punctuation	361400	21.1%
Space Separator	90350	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	332182	26.3%
1	214050	16.9%
2	163984	13.0%
5	136300	10.8%
9	113321	9.0%
6	108857	8.6%
3	67554	5.3%
4	52297	4.1%
8	49304	3.9%
7	27051	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	180700	50.0%
:	180700	50.0%

Space Separator

Value	Count	Frequency (%)
	90350	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1716650	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	332182	19.4%
1	214050	12.5%
/	180700	10.5%
:	180700	10.5%
2	163984	9.6%
5	136300	7.9%
9	113321	6.6%
6	108857	6.3%
	90350	5.3%
3	67554	3.9%
Other values (3)	128652	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1716650	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	332182	19.4%
1	214050	12.5%
/	180700	10.5%
:	180700	10.5%
2	163984	9.6%
5	136300	7.9%
9	113321	6.6%
6	108857	6.3%
	90350	5.3%
3	67554	3.9%
Other values (3)	128652	7.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	region	province	municipality	barangay	clustered_precinct	cayetano	escudero	honasan	marcos	robredo	trillanes	registered_voters	ballots_cast	precincts	polling_center	timestamp
0	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170026	25	47	8	230	138	8	592	503	0060A, 0060B, 0061A, 0062A	BUENLAG ELEMENTARY SCHOOL	05/09/2016 19:11:37
1	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170027	28	52	3	191	137	7	526	458	0062B, 0063A, 0063B, 0064A	BUENLAG ELEMENTARY SCHOOL	05/09/2016 18:39:48
2	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170023	32	75	5	295	156	12	723	649	0051C, 0052A, 0052B, 0053A, 0053B	BUENLAG ELEMENTARY SCHOOL	05/09/2016 18:36:49
3	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170022	50	91	5	291	172	14	768	650	0049A, 0050A, 0050B, 0051A, 0051B	BUENLAG ELEMENTARY SCHOOL	05/09/2016 17:12:03
4	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170025	58	96	3	303	162	14	787	662	0056C, 0057A, 0057B, 0058A, 0058B, 0059A, 0059B	BUENLAG ELEMENTARY SCHOOL	05/09/2016 18:34:08
5	REGION I	PANGASINAN	CALASIAO	BUENLAG	55170024	34	64	5	290	195	22	746	647	0054A, 0054B, 0055A, 0056A, 0056B	BUENLAG ELEMENTARY SCHOOL	05/09/2016 19:59:04
6	REGION I	PANGASINAN	CALASIAO	POBLACION EAST	55170002	43	63	1	245	154	7	600	531	0003A, 0003B, 0004A, 0005A, 0005B, 0006A	CALASIAO CENTRAL ELEMENTARY SCHOOL	05/09/2016 19:44:07
7	REGION I	PANGASINAN	CALASIAO	POBLACION EAST	55170001	40	93	3	174	118	7	520	471	0001A, 0001B, 0002A, 0002B	CALASIAO CENTRAL ELEMENTARY SCHOOL	05/09/2016 19:49:53
8	REGION I	PANGASINAN	CALASIAO	MANCUP	55170056	45	84	8	259	183	14	750	650	0132A, 0132B, 0133A, 0133B	MANCUP ELEMENTARY SCHOOL	05/09/2016 18:37:16
9	REGION I	PANGASINAN	CALASIAO	MANCUP	55170057	29	98	5	252	190	7	692	614	0133C, 0134A, 0134B, 0134C, 0135A	MANCUP ELEMENTARY SCHOOL	05/09/2016 17:51:39

Last rows

	region	province	municipality	barangay	clustered_precinct	cayetano	escudero	honasan	marcos	robredo	trillanes	registered_voters	ballots_cast	precincts	polling_center	timestamp
90632	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	TINGLAN	72080013	64	40	8	30	130	5	458	403	0025A, 0026A, 0026B	TINGLAN ELEMENTARY SCHOOL	05/10/2016 00:12:47
90633	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	ALVENDA	72080003	93	29	9	23	185	4	556	481	0006A, 0006B, 0007A, 0007B	ALVENDA ELEMENTARY SCHOOL	05/10/2016 02:23:07
90634	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	TOTONGON	72080014	53	35	18	19	68	0	298	273	0027A, 0027B	TOTONGON ELEMENTARY SCHOOL	05/09/2016 22:10:06
90635	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	BUENASUERTE	72080004	86	47	8	59	242	7	762	675	0008A, 0009A, 0010A, 0011A, 0011B	BUENA SUERTE ELEMENTARY SCHOOL	05/10/2016 02:21:48
90636	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	NEWLAND	72080009	96	37	8	16	82	4	421	382	0018A, 0019A, 0019B	JUAN DUMAOG ELEMENTARY SCHOOL	05/10/2016 20:21:35
90637	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	DILAND	72080005	59	26	2	14	122	4	327	284	0012A, 0013A	DILAND ELEMENTARY SCHOOL	05/09/2016 23:42:49
90638	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	HEAD TIPAN	72080007	41	10	3	12	106	0	252	235	0015A, 0016A	HEAD TIPAN ELEMENTARY SCHOOL	05/09/2016 21:59:44
90639	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	SANTO TOMAS	72080018	100	51	7	82	214	1	628	529	0035A, 0035B, 0036A, 0036B	MUTIA NATIONAL HIGH SCHOOL	05/09/2016 22:31:13
90640	REGION IX	ZAMBOANGA DEL NORTE	MUTIA	SANTO TOMAS	72080017	101	36	2	59	163	7	532	474	0032A, 0033A, 0034A	MUTIA NATIONAL HIGH SCHOOL	05/10/2016 23:11:07
90641	REGION XIII	SURIGAO DEL NORTE	CLAVER	TAYAGA (POB. EAST)	67060001	209	54	12	66	125	10	683	575	0001A, 0001B, 0002A, 0002B, 0007P1	CLAVER NATIONAL HIGH SCHOOL	05/09/2016 19:57:06

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories